#coding = utf-8
import pandas as pd

class readExcel:
    def readexcel(self,path,sheet_name):
        df = pd.read_excel(path, sheet_name=sheet_name, header=0)
        values = df.values
        #print(values)
        l = len(values)
        return values,l


if __name__ == '__main__':
    ob = readExcel()
    vs,l = ob.readexcel('../config/data.xls','user')
    for v in vs:
        username = v[0]
        phone = v[1]
        worksiteid = v[2]
        typeworkid = v[4]
        subid = v[6]
        isoverseer = v[7]
        print(username,phone,worksiteid,typeworkid,subid,isoverseer)




